﻿CREATE TABLE [dbo].[CONTRACT] (
    [ID]                      INT            IDENTITY (1, 1) NOT NULL,
    [NUMBER]                  NVARCHAR (50)  NOT NULL,
    [START_DATE]              DATE           NULL,
    [END_DATE]                DATE           NULL,
    [NSI_ORGANIZATION_ID]     INT            NULL,
    [NSI_TYPE_OF_ACTIVITY_ID] INT            NULL,
    [TYPE_WORK]               NVARCHAR (50)  NULL,
    [TYPE_DOC]                NVARCHAR (50)  NULL,
    [PARENT_CONTRACT_ID]      INT            NULL,
    [DESCRIPTION]             NVARCHAR (MAX) NULL,
    [LAST_UPDATE]             DATETIME2 (7)  NULL,
    [LAST_UPDATE_USER]        NVARCHAR (50)  NULL,
    [PID]                     INT            NULL
);







